<!DOCTYPE html><html lang="zh-CN" data-theme="light"><head><meta charset="UTF-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width,initial-scale=1"><title>UE4 MySQL插件使用 | Element</title><meta name="keywords" content="UnrealEngine"><meta name="author" content="FHang"><meta name="copyright" content="FHang"><meta name="format-detection" content="telephone=no"><meta name="theme-color" content="#ffffff"><meta http-equiv="Cache-Control" content="no-transform"><meta http-equiv="Cache-Control" content="no-siteapp"><meta name="description" content="UE4 MySQL插件使用1. 插件获取MySQL Plugin 提取码:17um 2. 插件安装 新建UE4项目，类型随意 在项目根目录中新建文件夹Plugins 将FH_MySQL复制到Plugins中 重新打开UE4项目  3. 插件API3.1 连接数据库 返回一个MySQL Connector 1234567&#x2F;* * Connection &#x3D;&#x3D; MySQL Object * @retur">
<meta property="og:type" content="article">
<meta property="og:title" content="UE4 MySQL插件使用">
<meta property="og:url" content="https://fhangh.gitee.io/article/cb9854b2.html">
<meta property="og:site_name" content="Element">
<meta property="og:description" content="UE4 MySQL插件使用1. 插件获取MySQL Plugin 提取码:17um 2. 插件安装 新建UE4项目，类型随意 在项目根目录中新建文件夹Plugins 将FH_MySQL复制到Plugins中 重新打开UE4项目  3. 插件API3.1 连接数据库 返回一个MySQL Connector 1234567&#x2F;* * Connection &#x3D;&#x3D; MySQL Object * @retur">
<meta property="og:locale" content="zh_CN">
<meta property="og:image" content="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_25.jpg">
<meta property="article:published_time" content="2022-03-27T06:49:30.840Z">
<meta property="article:modified_time" content="2022-05-19T04:29:51.469Z">
<meta property="article:author" content="FHang">
<meta property="article:tag" content="UnrealEngine">
<meta name="twitter:card" content="summary">
<meta name="twitter:image" content="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_25.jpg"><link rel="shortcut icon" href="/fhangh/img/fh.png"><link rel="canonical" href="https://fhangh.gitee.io/article/cb9854b2"><link rel="preconnect" href="//cdn.jsdelivr.net"/><link rel="preconnect" href="//busuanzi.ibruce.info"/><meta name="yandex-verification" content="{&quot;theme_color&quot;:{&quot;enable&quot;:true,&quot;main&quot;:&quot;#49B1F5&quot;,&quot;paginator&quot;:&quot;#00c4b6&quot;,&quot;button_hover&quot;:&quot;#FF7242&quot;,&quot;text_selection&quot;:&quot;#00c4b6&quot;,&quot;link_color&quot;:&quot;#99a9bf&quot;,&quot;meta_color&quot;:&quot;#858585&quot;,&quot;hr_color&quot;:&quot;#A4D8FA&quot;,&quot;code_foreground&quot;:&quot;#F47466&quot;,&quot;code_background&quot;:&quot;rgba(27, 31, 35, .05)&quot;,&quot;toc_color&quot;:&quot;#00c4b6&quot;,&quot;blockquote_padding_color&quot;:&quot;#49b1f5&quot;,&quot;blockquote_background_color&quot;:&quot;#49b1f5&quot;}}"/><link rel="stylesheet" href="/fhangh/css/index.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free/css/all.min.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fancyapps/fancybox@latest/dist/jquery.fancybox.min.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/node-snackbar/dist/snackbar.min.css"><script>var GLOBAL_CONFIG = { 
  root: '/fhangh/',
  algolia: undefined,
  localSearch: {"path":"search.xml","languages":{"hits_empty":"找不到您查询的内容：${query}"}},
  translate: undefined,
  noticeOutdate: undefined,
  highlight: {"plugin":"highlighjs","highlightCopy":true,"highlightLang":true},
  copy: {
    success: '复制成功',
    error: '复制错误',
    noSupport: '浏览器不支持'
  },
  relativeDate: {
    homepage: false,
    post: false
  },
  runtime: '天',
  date_suffix: {
    just: '刚刚',
    min: '分钟前',
    hour: '小时前',
    day: '天前',
    month: '个月前'
  },
  copyright: undefined,
  ClickShowText: undefined,
  lightbox: 'fancybox',
  Snackbar: {"chs_to_cht":"你已切换为繁体","cht_to_chs":"你已切换为简体","day_to_night":"你已切换为深色模式","night_to_day":"你已切换为浅色模式","bgLight":"#49b1f5","bgDark":"#121212","position":"top-right"},
  justifiedGallery: {
    js: 'https://cdn.jsdelivr.net/npm/justifiedGallery/dist/js/jquery.justifiedGallery.min.js',
    css: 'https://cdn.jsdelivr.net/npm/justifiedGallery/dist/css/justifiedGallery.min.css'
  },
  isPhotoFigcaption: false,
  islazyload: true,
  isanchor: false
};

var saveToLocal = {
  set: function setWithExpiry(key, value, ttl) {
    const now = new Date()
    const expiryDay = ttl * 86400000
    const item = {
      value: value,
      expiry: now.getTime() + expiryDay,
    }
    localStorage.setItem(key, JSON.stringify(item))
  },

  get: function getWithExpiry(key) {
    const itemStr = localStorage.getItem(key)

    if (!itemStr) {
      return undefined
    }
    const item = JSON.parse(itemStr)
    const now = new Date()

    if (now.getTime() > item.expiry) {
      localStorage.removeItem(key)
      return undefined
    }
    return item.value
  }
}</script><script id="config_change">var GLOBAL_CONFIG_SITE = { 
  isPost: true,
  isHome: false,
  isHighlightShrink: false,
  isToc: true,
  postUpdate: '2022-05-19 12:29:51'
}</script><noscript><style type="text/css">
  #nav {
    opacity: 1
  }
  .justified-gallery img {
    opacity: 1
  }

  #recent-posts time,
  #post-meta time {
    display: inline !important
  }
</style></noscript><script>(function () {  window.activateDarkMode = function () {
    document.documentElement.setAttribute('data-theme', 'dark')
    if (document.querySelector('meta[name="theme-color"]') !== null) {
      document.querySelector('meta[name="theme-color"]').setAttribute('content', '#0d0d0d')
    }
  }
  window.activateLightMode = function () {
    document.documentElement.setAttribute('data-theme', 'light')
   if (document.querySelector('meta[name="theme-color"]') !== null) {
      document.querySelector('meta[name="theme-color"]').setAttribute('content', '#ffffff')
    }
  }
  const autoChangeMode = 'false'
  const t = saveToLocal.get('theme')
  if (autoChangeMode === '1') {
    const isDarkMode = window.matchMedia('(prefers-color-scheme: dark)').matches
    const isLightMode = window.matchMedia('(prefers-color-scheme: light)').matches
    const isNotSpecified = window.matchMedia('(prefers-color-scheme: no-preference)').matches
    const hasNoSupport = !isDarkMode && !isLightMode && !isNotSpecified
    if (t === undefined) {
      if (isLightMode) activateLightMode()
      else if (isDarkMode) activateDarkMode()
      else if (isNotSpecified || hasNoSupport) {
        const now = new Date()
        const hour = now.getHours()
        const isNight = hour <= 6 || hour >= 18
        isNight ? activateDarkMode() : activateLightMode()
      }
      window.matchMedia('(prefers-color-scheme: dark)').addListener(function (e) {
        if (saveToLocal.get('theme') === undefined) {
          e.matches ? activateDarkMode() : activateLightMode()
        }
      })
    } else if (t === 'light') activateLightMode()
    else activateDarkMode()
  } else if (autoChangeMode === '2') {
    const now = new Date()
    const hour = now.getHours()
    const isNight = hour <= 6 || hour >= 18
    if (t === undefined) isNight ? activateDarkMode() : activateLightMode()
    else if (t === 'light') activateLightMode()
    else activateDarkMode()
  } else {
    if (t === 'dark') activateDarkMode()
    else if (t === 'light') activateLightMode()
  }const asideStatus = saveToLocal.get('aside-status')
if (asideStatus !== undefined) {
   if (asideStatus === 'hide') {
     document.documentElement.classList.add('hide-aside')
   } else {
     document.documentElement.classList.remove('hide-aside')
   }
}})()</script><meta name="generator" content="Hexo 5.3.0"></head><body><div id="loading-box"><div class="loading-left-bg"></div><div class="loading-right-bg"></div><div class="spinner-box"><div class="configure-border-1"><div class="configure-core"></div></div><div class="configure-border-2"><div class="configure-core"></div></div><div class="loading-word">加载中...</div></div></div><div id="web_bg"></div><div id="sidebar"><div id="menu-mask"></div><div id="sidebar-menus"><div class="author-avatar"><img class="avatar-img" data-lazy-src="/fhangh/img/fh.png" onerror="onerror=null;src='/img/friend_404.gif'" alt="avatar"/></div><div class="site-data"><div class="data-item is-center"><div class="data-item-link"><a href="/fhangh/archives/"><div class="headline">文章</div><div class="length-num">26</div></a></div></div><div class="data-item is-center"><div class="data-item-link"><a href="/fhangh/tags/"><div class="headline">标签</div><div class="length-num">10</div></a></div></div><div class="data-item is-center"><div class="data-item-link"><a href="/fhangh/categories/"><div class="headline">分类</div><div class="length-num">4</div></a></div></div></div><hr/><div class="menus_items"><div class="menus_item"><a class="site-page" href="/fhangh/"><i class="fa-fw fas fa-home"></i><span> 主页</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/archives/"><i class="fa-fw fas fa-archive"></i><span> 归档</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/tags/"><i class="fa-fw fas fa-tags"></i><span> 标签</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/categories/"><i class="fa-fw fas fa-folder-open"></i><span> 分类</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/link/"><i class="fa-fw fas fa-link"></i><span> 友链</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/about/"><i class="fa-fw fas fa-heart"></i><span> 关于</span></a></div><div class="menus_item"><a class="site-page" href="javascript:void(0);"><i class="fa-fw fas fa-list"></i><span> 列表</span><i class="fas fa-chevron-down expand"></i></a><ul class="menus_item_child"><li><a class="site-page" href="/fhangh/music/"><i class="fa-fw fas fa-music"></i><span> Music</span></a></li><li><a class="site-page" href="/fhangh/movies/"><i class="fa-fw fas fa-video"></i><span> Movie</span></a></li><li><a class="site-page" href="/fhangh/Gallery/"><i class="fa-fw fas fa-images"></i><span> Image</span></a></li></ul></div></div></div></div><div id="body-wrap"><header class="post-bg" id="page-header" style="background-image: url(https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img/postImg_25.jpg)"><nav id="nav"><span id="blog_name"><a id="site-name" href="/fhangh/">Element</a></span><span id="menus"><div id="search_button"><a class="site-page social-icon search"><i class="fas fa-search fa-fw"></i><span> 搜索</span></a></div><div class="menus_items"><div class="menus_item"><a class="site-page" href="/fhangh/"><i class="fa-fw fas fa-home"></i><span> 主页</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/archives/"><i class="fa-fw fas fa-archive"></i><span> 归档</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/tags/"><i class="fa-fw fas fa-tags"></i><span> 标签</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/categories/"><i class="fa-fw fas fa-folder-open"></i><span> 分类</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/link/"><i class="fa-fw fas fa-link"></i><span> 友链</span></a></div><div class="menus_item"><a class="site-page" href="/fhangh/about/"><i class="fa-fw fas fa-heart"></i><span> 关于</span></a></div><div class="menus_item"><a class="site-page" href="javascript:void(0);"><i class="fa-fw fas fa-list"></i><span> 列表</span><i class="fas fa-chevron-down expand"></i></a><ul class="menus_item_child"><li><a class="site-page" href="/fhangh/music/"><i class="fa-fw fas fa-music"></i><span> Music</span></a></li><li><a class="site-page" href="/fhangh/movies/"><i class="fa-fw fas fa-video"></i><span> Movie</span></a></li><li><a class="site-page" href="/fhangh/Gallery/"><i class="fa-fw fas fa-images"></i><span> Image</span></a></li></ul></div></div><span class="close" id="toggle-menu"><a class="site-page"><i class="fas fa-bars fa-fw"></i></a></span></span></nav><div id="post-info"><h1 class="post-title">UE4 MySQL插件使用</h1><div id="post-meta"><div class="meta-firstline"><span class="post-meta-date"><i class="far fa-calendar-alt fa-fw post-meta-icon"></i><span class="post-meta-label">发表于</span><time class="post-meta-date-created" datetime="2022-03-27T06:49:30.840Z" title="发表于 2022-03-27 14:49:30">2022-03-27</time><span class="post-meta-separator">|</span><i class="fas fa-history fa-fw post-meta-icon"></i><span class="post-meta-label">更新于</span><time class="post-meta-date-updated" datetime="2022-05-19T04:29:51.469Z" title="更新于 2022-05-19 12:29:51">2022-05-19</time></span><span class="post-meta-categories"><span class="post-meta-separator">|</span><i class="fas fa-inbox fa-fw post-meta-icon"></i><a class="post-meta-categories" href="/fhangh/categories/UnrealEngine/">UnrealEngine</a></span></div><div class="meta-secondline"> <span class="post-meta-separator">|</span><span class="post-meta-wordcount"><i class="far fa-file-word fa-fw post-meta-icon"></i><span class="post-meta-label">字数总计:</span><span class="word-count">812</span><span class="post-meta-separator">|</span><i class="far fa-clock fa-fw post-meta-icon"></i><span class="post-meta-label">阅读时长:</span><span>4分钟</span></span><span class="post-meta-separator">|</span><span class="post-meta-pv-cv"><i class="far fa-eye fa-fw post-meta-icon"></i><span class="post-meta-label">阅读量:</span><span id="busuanzi_value_page_pv"></span></span></div></div></div></header><main class="layout" id="content-inner"><div id="post"><article class="post-content" id="article-container"><h1 id="UE4-MySQL插件使用"><a href="#UE4-MySQL插件使用" class="headerlink" title="UE4 MySQL插件使用"></a>UE4 MySQL插件使用</h1><h3 id="1-插件获取"><a href="#1-插件获取" class="headerlink" title="1. 插件获取"></a>1. 插件获取</h3><p><a target="_blank" rel="noopener" href="https://www.aliyundrive.com/s/UiPTz9mnNUV">MySQL Plugin</a> 提取码:17um</p>
<h3 id="2-插件安装"><a href="#2-插件安装" class="headerlink" title="2. 插件安装"></a>2. 插件安装</h3><ol>
<li>新建<code>UE4</code>项目，类型随意</li>
<li>在<code>项目根目录</code>中新建文件夹<code>Plugins</code></li>
<li>将<code>FH_MySQL</code>复制到<code>Plugins</code>中</li>
<li>重新打开<code>UE4项目</code></li>
</ol>
<h3 id="3-插件API"><a href="#3-插件API" class="headerlink" title="3. 插件API"></a>3. 插件API</h3><h4 id="3-1-连接数据库"><a href="#3-1-连接数据库" class="headerlink" title="3.1 连接数据库"></a>3.1 连接数据库</h4><ul>
<li><p>返回一个<code>MySQL Connector</code></p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * Connection == MySQL Object</span></span><br><span class="line"><span class="comment"> * @return *UFH_ConnectionObject == MySQL Connector</span></span><br><span class="line"><span class="comment">*/</span></span><br><span class="line">UFUNCTION(BlueprintCallable, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> UFH_ConnectionObject *<span class="title">ConnectToMySQL</span><span class="params">(FString Host, FString UserName, FString PassWord, FString DBName,</span></span></span><br><span class="line"><span class="function"><span class="params">                                            int32 Port, FString &amp;ConnectMessage)</span></span>;</span><br></pre></td></tr></table></figure>






</li>
</ul>
<h4 id="3-2-获得连接状态"><a href="#3-2-获得连接状态" class="headerlink" title="3.2 获得连接状态"></a>3.2 获得连接状态</h4><ul>
<li><p>返回<code>bool</code>，正在连接返回<code>true</code></p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * ConnectionObject == MySQL Object</span></span><br><span class="line"><span class="comment"> * @return bool == ConnectionState</span></span><br><span class="line"><span class="comment">*/</span></span><br><span class="line">UFUNCTION(BlueprintCallable, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> <span class="keyword">bool</span> <span class="title">GetConnectionState</span><span class="params">(UFH_ConnectionObject *ConnectionObject)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h4 id="3-3-关闭数据库连接"><a href="#3-3-关闭数据库连接" class="headerlink" title="3.3 关闭数据库连接"></a>3.3 关闭数据库连接</h4><ul>
<li><p>肯定会关掉，默认返回<code>true</code></p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * ConnectionObject == MySQL Object</span></span><br><span class="line"><span class="comment"> * @return bool == ConnectionState</span></span><br><span class="line"><span class="comment">*/</span></span><br><span class="line">UFUNCTION(BlueprintCallable, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> <span class="keyword">bool</span> <span class="title">CloseConnection</span><span class="params">(UFH_ConnectionObject *ConnectionObject)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h4 id="3-4-增-删-改处理"><a href="#3-4-增-删-改处理" class="headerlink" title="3.4 增-删-改处理"></a>3.4 增-删-改处理</h4><ul>
<li><p>实现增删改的处理，具体执行程序依据传入<code>格式化SqlQuery</code></p>
</li>
<li><p><code>Insert</code>，<code>Delete</code>，<code>Update</code></p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * ConnectionObject == MySQL Object</span></span><br><span class="line"><span class="comment"> * @return bool == Insert, Update, Delete Data Is Succeed Or Failed</span></span><br><span class="line"><span class="comment">*/</span></span><br><span class="line">UFUNCTION(BlueprintCallable, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> <span class="keyword">bool</span> <span class="title">ActionOnTableData</span><span class="params">(UFH_ConnectionObject *ConnectionObject, FString SqlQuery)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h5 id="3-4-1-Insert-Format-SqlQuery"><a href="#3-4-1-Insert-Format-SqlQuery" class="headerlink" title="3.4.1 Insert Format SqlQuery"></a>3.4.1 Insert Format SqlQuery</h5><ul>
<li><p>通用的 <code>INSERT INTO TableName VALUES(InsertValues);</code>格式化插入语句</p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * TableName = DataBase TableName</span></span><br><span class="line"><span class="comment"> * InsertValues = MySQL Insert Values to Table</span></span><br><span class="line"><span class="comment"> * @return FString = MySQL Insert Query -&gt; Insert</span></span><br><span class="line"><span class="comment">*/</span></span><br><span class="line">UFUNCTION(BlueprintPure, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> FString <span class="title">InsertFormatSqlQuery</span><span class="params">(FString TableName, FString InsertValues)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h5 id="3-4-2-Update-Format-SqlQuery"><a href="#3-4-2-Update-Format-SqlQuery" class="headerlink" title="3.4.2 Update Format SqlQuery"></a>3.4.2 Update Format SqlQuery</h5><ul>
<li><p>更新所有字段的值<code>UPDATE TableName SET RowName = UpdateValue;</code>格式化更新语句</p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * TableName = DataBase TableName</span></span><br><span class="line"><span class="comment"> * RowName = Need Update Row</span></span><br><span class="line"><span class="comment"> * @return FString = MySQL Update Query -&gt; Update</span></span><br><span class="line"><span class="comment">*/</span>	</span><br><span class="line">UFUNCTION(BlueprintPure, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> FString <span class="title">UpdateAllFormatSqlQuery</span><span class="params">(FString TableName, FString RowName, FString UpdateValue)</span></span>;</span><br></pre></td></tr></table></figure>


</li>
</ul>
<ul>
<li><p>依据条件更新字段值<code>UPDATE TableName SET UpdateRowName = UpdateValue WHERE WhereName = WhereValue;</code>格式化更新语句</p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * TableName = DataBase TableName</span></span><br><span class="line"><span class="comment"> * RowName = Need Update Row</span></span><br><span class="line"><span class="comment"> * WhereName = Update Where</span></span><br><span class="line"><span class="comment"> * WhereSymbol = Operator Or Symbol</span></span><br><span class="line"><span class="comment"> * WhereValue = Condition Name</span></span><br><span class="line"><span class="comment"> * UpdateValue = Need Update Date Value</span></span><br><span class="line"><span class="comment"> * @return FString = MySQL Update Query -&gt; Update</span></span><br><span class="line"><span class="comment">*/</span>	</span><br><span class="line">UFUNCTION(BlueprintPure, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> FString <span class="title">UpdateByWhereFormatSqlQuery</span><span class="params">(FString TableName, FString RowName, FString WhereName, </span></span></span><br><span class="line"><span class="function"><span class="params">                                           FString WhereSymbol, FString WhereValue, FString UpdateValue)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h5 id="3-4-3-Delete-Format-SqlQuery"><a href="#3-4-3-Delete-Format-SqlQuery" class="headerlink" title="3.4.3 Delete Format SqlQuery"></a>3.4.3 Delete Format SqlQuery</h5><ul>
<li><p>删除整个表<code>DELETE FROM TableName;</code>格式化删除语句</p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * TableName = DataBase TableName</span></span><br><span class="line"><span class="comment"> * @return FString = MySQL Delete Query -&gt; Delete</span></span><br><span class="line"><span class="comment">*/</span></span><br><span class="line">UFUNCTION(BlueprintPure, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> FString <span class="title">DeleteAllFormatSqlQuery</span><span class="params">(FString TableName)</span></span>;</span><br></pre></td></tr></table></figure>


</li>
</ul>
<ul>
<li><p>依据条件删除整行数据<code>DELETE FROM TableName WHERE WhereName=‘WhereValue’;</code>格式化删除语句</p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * TableName = DataBase TableName</span></span><br><span class="line"><span class="comment"> * WhereName = Update Where</span></span><br><span class="line"><span class="comment"> * WhereSymbol = Operator Or Symbol</span></span><br><span class="line"><span class="comment"> * WhereValue = Condition Name</span></span><br><span class="line"><span class="comment"> * @return FString = MySQL Delete Query -&gt; Delete</span></span><br><span class="line"><span class="comment">*/</span></span><br><span class="line">UFUNCTION(BlueprintPure, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> FString <span class="title">DeleteByWhereFormatSqlQuery</span><span class="params">(FString TableName, FString WhereName, FString WhereSymbol, </span></span></span><br><span class="line"><span class="function"><span class="params">                                           FString WhereValue)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h4 id="3-5-查询语句处理"><a href="#3-5-查询语句处理" class="headerlink" title="3.5 查询语句处理"></a>3.5 查询语句处理</h4><ul>
<li>实现基本常用的查询语句：<ol>
<li><code>SELECT * FROM TableName;</code></li>
<li><code>SELECT Columns1, Columns2, Country FROM TableName;</code></li>
<li><code>获得指定行的整行数据</code></li>
</ol>
</li>
</ul>
<ul>
<li><p>处理查询语句的通用，具体执行程序依据传入<code>格式化SqlQuery</code></p>
</li>
<li><p>函数公开生成并返回<code>struct</code>类型：</p>
<ul>
<li><code>ResultRows</code>整个表的数据</li>
<li><code>ResultRow</code>整行的数据</li>
<li><code>RowValue</code>整行内字段名的数据</li>
</ul>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * ConnectionObject == MySQL Object</span></span><br><span class="line"><span class="comment"> * @return bool == Select Data Is Succeed Or Failed</span></span><br><span class="line"><span class="comment">*/</span>	</span><br><span class="line">UFUNCTION(BlueprintCallable, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> <span class="keyword">bool</span> <span class="title">SelectOnTableData</span><span class="params">(UFH_ConnectionObject *ConnectionObject, FString SqlQuery, </span></span></span><br><span class="line"><span class="function"><span class="params">                              FQueryResultRows &amp;ResultRows)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h5 id="3-5-1-Select-All-Format-SqlQuery"><a href="#3-5-1-Select-All-Format-SqlQuery" class="headerlink" title="3.5.1 Select All Format SqlQuery"></a>3.5.1 Select All Format SqlQuery</h5><ul>
<li><p>查询整个表的数据<code>SELECT * FROM TableName;</code>格式化查询语句</p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * TableName = DataBase TableName</span></span><br><span class="line"><span class="comment"> * @return FString = MySQL Select Query -&gt; Select</span></span><br><span class="line"><span class="comment">*/</span></span><br><span class="line">UFUNCTION(BlueprintPure, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> FString <span class="title">SelectAllFormatSqlQuery</span><span class="params">(FString TableName)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h5 id="3-5-2-Select-Columns-By-Conditions"><a href="#3-5-2-Select-Columns-By-Conditions" class="headerlink" title="3.5.2 Select Columns By Conditions"></a>3.5.2 Select Columns By Conditions</h5><ul>
<li><p>依据条件查询表内数据<code>SELECT Columns1, Columns2, Country FROM TableName;</code>格式化查询语句</p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * TableName = DataBase TableName</span></span><br><span class="line"><span class="comment"> * @return FString = MySQL Select Query -&gt; Select</span></span><br><span class="line"><span class="comment">*/</span>	</span><br><span class="line">UFUNCTION(BlueprintPure, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> FString <span class="title">SelectByColumnsFormatSqlQuery</span><span class="params">(FString TableName, FString Columns)</span></span>;</span><br></pre></td></tr></table></figure>




</li>
</ul>
<h5 id="3-5-3-Select-Get-RowValues-By-Index"><a href="#3-5-3-Select-Get-RowValues-By-Index" class="headerlink" title="3.5.3 Select Get RowValues By Index"></a>3.5.3 Select Get RowValues By Index</h5><ul>
<li><p>指定表面和表内的行号，查询数据</p>
<figure class="highlight c++"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br></pre></td><td class="code"><pre><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment"> * TableName = DataBase TableName</span></span><br><span class="line"><span class="comment"> * @return TArray&lt;FString&gt; = Get All Rows -&gt; In All Columns Values</span></span><br><span class="line"><span class="comment">*/</span>		</span><br><span class="line">UFUNCTION(BlueprintPure, Category=<span class="string">&quot;MySQL|Utils&quot;</span>)</span><br><span class="line"><span class="function"><span class="keyword">static</span> FQueryResultRow <span class="title">GetRowByIndex</span><span class="params">(<span class="keyword">const</span> FQueryResultRows &amp;ResultRows, int32 RowIndex)</span></span>;</span><br></pre></td></tr></table></figure>
</li>
</ul>
</article><div class="post-copyright"><div class="post-copyright__author"><span class="post-copyright-meta">文章作者: </span><span class="post-copyright-info"><a href="mailto:undefined">FHang</a></span></div><div class="post-copyright__type"><span class="post-copyright-meta">文章链接: </span><span class="post-copyright-info"><a href="https://fhangh.gitee.io/article/cb9854b2.html">https://fhangh.gitee.io/article/cb9854b2.html</a></span></div><div class="post-copyright__notice"><span class="post-copyright-meta">版权声明: </span><span class="post-copyright-info">本博客所有文章除特别声明外，均采用 <a href="https://creativecommons.org/licenses/by-nc-sa/4.0/" target="_blank">CC BY-NC-SA 4.0</a> 许可协议。转载请注明来自 <a href="https://fhangh.gitee.io" target="_blank">Element</a>！</span></div></div><div class="tag_share"><div class="post-meta__tag-list"><a class="post-meta__tags" href="/fhangh/tags/UnrealEngine/">UnrealEngine</a></div><div class="post_share"><div class="social-share" data-image="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_25.jpg" data-sites="facebook,twitter,wechat,weibo,qq"></div><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/social-share.js/dist/css/share.min.css"><script src="https://cdn.jsdelivr.net/npm/social-share.js/dist/js/social-share.min.js" defer></script></div></div><nav class="pagination-post" id="pagination"><div class="prev-post pull-left"><a href="/fhangh/article/7dd18469.html"><img class="prev-cover" data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_26.jpg" onerror="onerror=null;src='/fhangh/img/404.jpg'"><div class="pagination-info"><div class="label">上一篇</div><div class="prev_info">UE4 RPC</div></div></a></div><div class="next-post pull-right"><a href="/fhangh/article/605bd1ac.html"><img class="next-cover" data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_24.jpg" onerror="onerror=null;src='/fhangh/img/404.jpg'"><div class="pagination-info"><div class="label">下一篇</div><div class="next_info">UE4 MySQL插件开发</div></div></a></div></nav><div class="relatedPosts"><div class="headline"><i class="fas fa-thumbs-up fa-fw"></i><span> 相关推荐</span></div><div class="relatedPosts-list"><div><a href="/fhangh/article/3fadb38f.html" title="UE4联网和多人游戏"><img class="cover" data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_27.jpg" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2022-05-26</div><div class="title">UE4联网和多人游戏</div></div></a></div><div><a href="/fhangh/article/7dd18469.html" title="UE4 RPC"><img class="cover" data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_26.jpg" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2022-05-19</div><div class="title">UE4 RPC</div></div></a></div><div><a href="/fhangh/article/605bd1ac.html" title="UE4 MySQL插件开发"><img class="cover" data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_24.jpg" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2022-03-26</div><div class="title">UE4 MySQL插件开发</div></div></a></div><div><a href="/fhangh/article/80740681.html" title="UE4初始设置及个人使用崩溃记录"><img class="cover" data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_10.jpg" alt="cover"><div class="content is-center"><div class="date"><i class="far fa-calendar-alt fa-fw"></i> 2021-03-13</div><div class="title">UE4初始设置及个人使用崩溃记录</div></div></a></div></div></div></div><div class="aside_content" id="aside_content"><div class="card-widget card-info"><div class="card-content"><div class="card-info-avatar is-center"><img class="avatar-img" data-lazy-src="/fhangh/img/fh.png" onerror="this.onerror=null;this.src='/fhangh/img/friend_404.gif'" alt="avatar"/><div class="author-info__name">FHang</div><div class="author-info__description"></div></div><div class="card-info-data"><div class="card-info-data-item is-center"><a href="/fhangh/archives/"><div class="headline">文章</div><div class="length-num">26</div></a></div><div class="card-info-data-item is-center"><a href="/fhangh/tags/"><div class="headline">标签</div><div class="length-num">10</div></a></div><div class="card-info-data-item is-center"><a href="/fhangh/categories/"><div class="headline">分类</div><div class="length-num">4</div></a></div></div><a class="button--animated" id="card-info-btn" target="_blank" rel="noopener" href="https://github.com/FHangH"><i class="fab fa-github"></i><span>Link To</span></a><div class="card-info-social-icons is-center"><a class="social-icon" href="https://github.com/FHangH" target="_blank" title="Github"><i class="fab fa-github"></i></a><a class="social-icon" href="mailto:752972182@qq.com" target="_blank" title="Email"><i class="fas fa-envelope"></i></a></div></div></div><div class="card-widget card-announcement"><div class="card-content"><div class="item-headline"><i class="fas fa-bullhorn card-announcement-animation"></i><span>公告</span></div><div class="announcement_content">个人学习笔记</div></div></div><div class="sticky_layout"><div class="card-widget" id="card-toc"><div class="card-content"><div class="item-headline"><i class="fas fa-stream"></i><span>目录</span></div><div class="toc-content"><ol class="toc"><li class="toc-item toc-level-1"><a class="toc-link" href="#UE4-MySQL%E6%8F%92%E4%BB%B6%E4%BD%BF%E7%94%A8"><span class="toc-number">1.</span> <span class="toc-text">UE4 MySQL插件使用</span></a><ol class="toc-child"><li class="toc-item toc-level-3"><a class="toc-link" href="#1-%E6%8F%92%E4%BB%B6%E8%8E%B7%E5%8F%96"><span class="toc-number">1.0.1.</span> <span class="toc-text">1. 插件获取</span></a></li><li class="toc-item toc-level-3"><a class="toc-link" href="#2-%E6%8F%92%E4%BB%B6%E5%AE%89%E8%A3%85"><span class="toc-number">1.0.2.</span> <span class="toc-text">2. 插件安装</span></a></li><li class="toc-item toc-level-3"><a class="toc-link" href="#3-%E6%8F%92%E4%BB%B6API"><span class="toc-number">1.0.3.</span> <span class="toc-text">3. 插件API</span></a><ol class="toc-child"><li class="toc-item toc-level-4"><a class="toc-link" href="#3-1-%E8%BF%9E%E6%8E%A5%E6%95%B0%E6%8D%AE%E5%BA%93"><span class="toc-number">1.0.3.1.</span> <span class="toc-text">3.1 连接数据库</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#3-2-%E8%8E%B7%E5%BE%97%E8%BF%9E%E6%8E%A5%E7%8A%B6%E6%80%81"><span class="toc-number">1.0.3.2.</span> <span class="toc-text">3.2 获得连接状态</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#3-3-%E5%85%B3%E9%97%AD%E6%95%B0%E6%8D%AE%E5%BA%93%E8%BF%9E%E6%8E%A5"><span class="toc-number">1.0.3.3.</span> <span class="toc-text">3.3 关闭数据库连接</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#3-4-%E5%A2%9E-%E5%88%A0-%E6%94%B9%E5%A4%84%E7%90%86"><span class="toc-number">1.0.3.4.</span> <span class="toc-text">3.4 增-删-改处理</span></a><ol class="toc-child"><li class="toc-item toc-level-5"><a class="toc-link" href="#3-4-1-Insert-Format-SqlQuery"><span class="toc-number">1.0.3.4.1.</span> <span class="toc-text">3.4.1 Insert Format SqlQuery</span></a></li><li class="toc-item toc-level-5"><a class="toc-link" href="#3-4-2-Update-Format-SqlQuery"><span class="toc-number">1.0.3.4.2.</span> <span class="toc-text">3.4.2 Update Format SqlQuery</span></a></li><li class="toc-item toc-level-5"><a class="toc-link" href="#3-4-3-Delete-Format-SqlQuery"><span class="toc-number">1.0.3.4.3.</span> <span class="toc-text">3.4.3 Delete Format SqlQuery</span></a></li></ol></li><li class="toc-item toc-level-4"><a class="toc-link" href="#3-5-%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E5%A4%84%E7%90%86"><span class="toc-number">1.0.3.5.</span> <span class="toc-text">3.5 查询语句处理</span></a><ol class="toc-child"><li class="toc-item toc-level-5"><a class="toc-link" href="#3-5-1-Select-All-Format-SqlQuery"><span class="toc-number">1.0.3.5.1.</span> <span class="toc-text">3.5.1 Select All Format SqlQuery</span></a></li><li class="toc-item toc-level-5"><a class="toc-link" href="#3-5-2-Select-Columns-By-Conditions"><span class="toc-number">1.0.3.5.2.</span> <span class="toc-text">3.5.2 Select Columns By Conditions</span></a></li><li class="toc-item toc-level-5"><a class="toc-link" href="#3-5-3-Select-Get-RowValues-By-Index"><span class="toc-number">1.0.3.5.3.</span> <span class="toc-text">3.5.3 Select Get RowValues By Index</span></a></li></ol></li></ol></li></ol></li></ol></li></ol></div></div></div><div class="card-widget card-recent-post"><div class="card-content"><div class="item-headline"><i class="fas fa-history"></i><span>最新文章</span></div><div class="aside-list"><div class="aside-list-item"><a class="thumbnail" href="/fhangh/article/3fadb38f.html" title="UE4联网和多人游戏"><img data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_27.jpg" onerror="this.onerror=null;this.src='/fhangh/img/404.jpg'" alt="UE4联网和多人游戏"/></a><div class="content"><a class="title" href="/fhangh/article/3fadb38f.html" title="UE4联网和多人游戏">UE4联网和多人游戏</a><time datetime="2022-05-26T14:04:45.432Z" title="发表于 2022-05-26 22:04:45">2022-05-26</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/fhangh/article/7dd18469.html" title="UE4 RPC"><img data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_26.jpg" onerror="this.onerror=null;this.src='/fhangh/img/404.jpg'" alt="UE4 RPC"/></a><div class="content"><a class="title" href="/fhangh/article/7dd18469.html" title="UE4 RPC">UE4 RPC</a><time datetime="2022-05-19T04:30:00.826Z" title="发表于 2022-05-19 12:30:00">2022-05-19</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/fhangh/article/cb9854b2.html" title="UE4 MySQL插件使用"><img data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_25.jpg" onerror="this.onerror=null;this.src='/fhangh/img/404.jpg'" alt="UE4 MySQL插件使用"/></a><div class="content"><a class="title" href="/fhangh/article/cb9854b2.html" title="UE4 MySQL插件使用">UE4 MySQL插件使用</a><time datetime="2022-03-27T06:49:30.840Z" title="发表于 2022-03-27 14:49:30">2022-03-27</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/fhangh/article/605bd1ac.html" title="UE4 MySQL插件开发"><img data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_24.jpg" onerror="this.onerror=null;this.src='/fhangh/img/404.jpg'" alt="UE4 MySQL插件开发"/></a><div class="content"><a class="title" href="/fhangh/article/605bd1ac.html" title="UE4 MySQL插件开发">UE4 MySQL插件开发</a><time datetime="2022-03-26T07:56:25.807Z" title="发表于 2022-03-26 15:56:25">2022-03-26</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/fhangh/article/f7ede91d.html" title="Java基础"><img data-lazy-src="https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img_mini/postImg_19.jpg" onerror="this.onerror=null;this.src='/fhangh/img/404.jpg'" alt="Java基础"/></a><div class="content"><a class="title" href="/fhangh/article/f7ede91d.html" title="Java基础">Java基础</a><time datetime="2021-12-12T07:47:44.788Z" title="发表于 2021-12-12 15:47:44">2021-12-12</time></div></div></div></div></div></div></div></main><footer id="footer" style="background-image: url(https://cdn.jsdelivr.net/gh/FHangH/FHangBlogCDN/Post_Img/postImg_25.jpg)"><div id="footer-wrap"><div class="copyright">&copy;2020 - 2022 By FHang</div><div class="framework-info"><span>框架 </span><a target="_blank" rel="noopener" href="https://hexo.io">Hexo</a><span class="footer-separator">|</span><span>主题 </span><a target="_blank" rel="noopener" href="https://github.com/jerryc127/hexo-theme-butterfly">Butterfly</a></div></div></footer></div><div id="rightside"><div id="rightside-config-hide"><button id="readmode" type="button" title="阅读模式"><i class="fas fa-book-open"></i></button><button id="darkmode" type="button" title="浅色和深色模式转换"><i class="fas fa-adjust"></i></button><button id="hide-aside-btn" type="button"><i class="fas fa-arrows-alt-h"></i></button></div><div id="rightside-config-show"><button id="rightside_config" type="button" title="设置"><i class="fas fa-cog"></i></button><button class="close" id="mobile-toc-button" type="button" title="目录"><i class="fas fa-list-ul"></i></button><button id="go-up" type="button" title="回到顶部"><i class="fas fa-arrow-up"></i></button></div></div><div id="local-search"><div class="search-dialog"><div class="search-dialog__title" id="local-search-title">本地搜索</div><div id="local-input-panel"><div id="local-search-input"><div class="local-search-box"><input class="local-search-box--input" placeholder="搜索文章" type="text"/></div></div></div><hr/><div id="local-search-results"><div id="local-hits"></div><div id="local-stats"><div class="local-search-stats__hr" id="hr"><span>由</span> <a target="_blank" rel="noopener" href="https://github.com/wzpan/hexo-generator-search" style="color:#49B1F5;">hexo-generator-search</a>
 <span>提供支持</span></div></div></div><span class="search-close-button"><i class="fas fa-times"></i></span></div><div id="search-mask"></div></div><div><script src="https://cdn.jsdelivr.net/npm/jquery@latest/dist/jquery.min.js"></script><script src="/fhangh/js/utils.js"></script><script src="/fhangh/js/main.js"></script><script src="https://cdn.jsdelivr.net/npm/@fancyapps/fancybox@latest/dist/jquery.fancybox.min.js"></script><script src="https://cdn.jsdelivr.net/npm/vanilla-lazyload/dist/lazyload.iife.min.js"></script><script src="https://cdn.jsdelivr.net/npm/node-snackbar/dist/snackbar.min.js"></script><script src="/fhangh/js/search/local-search.js"></script><script>var preloader = {
  endLoading: () => {
    document.body.style.overflow = 'auto';
    document.getElementById('loading-box').classList.add("loaded")
  },
  initLoading: () => {
    document.body.style.overflow = '';
    document.getElementById('loading-box').classList.remove("loaded")

  }
}
window.addEventListener('load',()=> {preloader.endLoading()})</script><div class="js-pjax"><script async src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js"></script></div><script defer="defer" id="fluttering_ribbon" mobile="false" src="https://cdn.jsdelivr.net/npm/butterfly-extsrc@1/dist/canvas-fluttering-ribbon.min.js"></script><script id="click-heart" src="https://cdn.jsdelivr.net/npm/butterfly-extsrc@1/dist/click-heart.min.js" async="async" mobile="true"></script></div></body></html>